create external table jms_dim.dim_tab_take_delivery_base (
  `id` bigint COMMENT '主键id',
  `booking_space_no` bigint COMMENT '订舱号',
  `landing_time` timestamp COMMENT '实际落地时间',
  `goods_quantity` int COMMENT '实际到件件数',
  `goods_weight` double COMMENT '实际到件重量',
  `destination_center_id` bigint COMMENT '目的地转运中心id',
  `destination_center_code` string COMMENT '',
  `destination_center_name` string COMMENT '目的地转运中心name',
  `take_delivery_time` timestamp COMMENT '提货上报时间',
  `report_person` string COMMENT '提货上报人',
  `information` string COMMENT '异常情况',
  `send_goods_report_id` bigint COMMENT '发货上报记录表tab_send_goods_report关联主键id',
  	take_delivery_imgs string comment '货物图片',
	delivery_model string comment '提货车型',
	license_plate string comment '提货车牌号',
	vehicle_ownership string comment '提货车辆归属',
	destination_agent_area_id bigint comment '目的代理区id',
	destination_agent_area_name string comment '目的代理区name',
	destination_agent_area_code string comment '目的代理区code'
) comment '提货上报'
 stored as parquet
LOCATION
  '/dw/hive/jms_dim.db/external/dim_tab_take_delivery_base';